<!DOCTYPE html>
<html lang="en">
<head>
  <title>SchemaCrawler Output</title>
  <meta charset="utf-8"/>
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"/>
  <style>

body, p, li, td, th, caption, select, input, strong {
  font-family: "Century Gothic", CenturyGothic, Geneva, sans-serif;
  font-size: 1rem;
  line-height: 1.4rem;
  color: rgb(16, 16, 16);
}

body {
  margin: 1rem 3rem;
}

code, pre, tt {
  font-family: 'Lucida Console', Monaco, 'Courier New', monospace;
  font-size: 1rem;
  line-height: 1.4rem;
  color: rgb(16, 16, 16);
}

hr {
  height: 1px;
  border-width: 1px 0 0 0;
  color: silver;
}

p {
  margin-bottom: 0.5rem;
}

caption {
  border-bottom: 2px solid black;
  padding: 2px 5px;
  text-align: left;
}

h1, h2, h3 {
  font-family: "Palatino Linotype", Georgia, "Times New Roman", serif;
  margin-top: 1rem;
  margin-bottom: 1.5rem;
  font-weight: bold;
}

h1 {
  font-size: 1.6rem;
  line-height: 1.8rem;
}

h2 {
  font-size: 1.4rem;
  line-height: 1.6rem;
}

h3 {
  font-size: 1.2rem;
  line-height: 1.4rem;
}

dl, ul, ol {
  border: 0;
  background-color: #fff;
  margin-left: 1rem;
  padding: 0 0 0 1rem;
}

li {
  margin-top: 0.3rem;
}

table, th, td {
  border: 1px solid rgb(240, 240, 240);
  border-collapse: collapse;
  vertical-align: top;
  padding: 2px;
}

table {
  width: 800px;
  max-width: 1000px;
  min-width: 600px;
}

th {
  font-weight: bold;
  border-bottom: 1px solid rgb(190, 190, 190);
}

blockquote {
  background: #f9f9f9;
  margin: 5px;
  border-left: 10px solid #ccc;
  padding: 0.5rem 10px;
}

blockquote:before {
  color: #ccc;
  font-size: 4rem;
  line-height: 0.1rem;
  margin-right: 0.25rem;
  vertical-align: -0.4rem;
}

blockquote p {
  display: inline;
  background: #f9f9f9;
}

h1 {
  color: maroon;
}

h2 {
  color: darkblue;
}

h3 {
  color: green;
}

a:link, a:visited {
  color: rgb(123, 42, 144);
  text-decoration: none;
}

a:hover, a:active {
  color: rgb(123, 42, 144);
  background-color: rgb(255, 255, 180);
  text-decoration: none;
  border-bottom: 1px solid rgb(123, 42, 144);
  border-radius: 3px;
}

.caption_name {
  font-weight: bold;
  font-style: italic;
}

.caption_description {
  float: right;
}

.name {
  font-weight: bold;
  min-width: 350px;
}

.property_name {
  min-width: 350px;
}

.property_value {
  min-width: 250px;
}

.right {
  text-align: right;
}

.description {
  min-width: 450px;
}

.spacer {
  min-width: 20px;
}

.minwidth {
  min-width: 150px;
}

.definition {
  word-break: normal;
  word-wrap: break-word;
  white-space: pre;
  white-space: -moz-pre-wrap;
  white-space: pre-wrap;
  white-space: pre\9;

  font-family: 'Lucida Console', Monaco, 'Courier New', monospace;
  font-size: 1rem;
  font-weight: 100;

  line-height: 1.2rem;
  color: rgb(16, 16, 16);
}

.remarks {
  word-break: normal;
  word-wrap: break-word;
  white-space: pre;
  white-space: -moz-pre-wrap;
  white-space: pre-wrap;
  white-space: pre\9;
}

td:nth-of-type(1) {
  width: 30px;
}

td.section {
  font-family: "Palatino Linotype", Georgia, "Times New Roman", serif;
  padding-top: 1.5rem;
  padding-bottom: 1rem;
  font-weight: bold;
  font-size: 1.2rem;
  line-height: 1.2rem;
  color: rgb(100, 100, 100);
}

.data_binary {
  font-style: italic;
  color: rgb(64, 64, 64);
}

.data_null {
  font-style: italic;
  color: rgb(64, 64, 64);
  background-color: rgb(240, 240, 240);
}

.data_number {
  text-align: right;
  padding-right: 5px;
}


  </style>
</head>
<body>

<p>&#160;</p>
<h2>System Information</h2>

<table>
	<tr>
		<td class='property_name'>generated by</td>
		<td class='property_value'>SchemaCrawler 16.28.3</td>
	</tr>
	<tr>
		<td class='property_name'>generated on</td>
		<td class='property_value'>2025-10-01 00:31:20</td>
	</tr>
	<tr>
		<td class='property_name'>database version</td>
		<td class='property_value'>HSQL Database Engine 2.7.4</td>
	</tr>
	<tr>
		<td class='property_name'>driver version</td>
		<td class='property_value'>HSQL Database Engine Driver 2.7.4</td>
	</tr>
</table>
<p>&#160;</p>

<p>&#160;</p>
<h2>Tables</h2>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='authors_f521e766' class='caption_name'>PUBLIC.BOOKS.AUTHORS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td colspan='3' class='remarks'>Contact details for book authors</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'>VARCHAR(20) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'>VARCHAR(20) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ADDRESS1</td>
		<td class='minwidth'>VARCHAR(255)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ADDRESS2</td>
		<td class='minwidth'>VARCHAR(255)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>CITY</td>
		<td class='minwidth'>VARCHAR(50)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'>CHARACTER(2)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'>VARCHAR(10)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>VARCHAR(50)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth'>default 'USA'</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_AUTHORS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>Z_FK_AUTHOR</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#bookauthors_ead84c5d'>PUBLIC.BOOKS.BOOKAUTHORS.AUTHORID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_AUTHORS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>IDX_B_AUTHORS</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>IDX_A_AUTHORS</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>CITY</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Triggers</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>TRG_AUTHORS</td>
		<td class='description right'>[trigger]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>after delete, per row</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[action statement]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>UPDATE BOOKS.PUBLISHERS SET PUBLISHER='Jacob'WHERE PUBLISHER='John'</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>CHECK_UPPERCASE_STATE</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.AUTHORS.STATE=UPPER(BOOKS.AUTHORS.STATE)</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10102</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.AUTHORS.ID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10103</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.AUTHORS.FIRSTNAME IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10104</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.AUTHORS.LASTNAME IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Used By Objects</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS.BOOKAUTHORS</td>
		<td class='description right'>[table]</td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS.AUTHORSLIST</td>
		<td class='description right'>[view]</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='authorslist_9ccb3c04' class='caption_name'>PUBLIC.BOOKS.AUTHORSLIST</span>
		<span class='caption_description'>[view]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'>VARCHAR(20)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'>VARCHAR(20)</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>SELECT ID,FIRSTNAME,LASTNAME FROM BOOKS.AUTHORS</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Usage</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS.AUTHORS</td>
		<td class='description right'>[table]</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='bookauthors_ead84c5d' class='caption_name'>PUBLIC.BOOKS.BOOKAUTHORS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td colspan='3' class='remarks'>Relationship between books and their authors, 
along with the latest updated information</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID</td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>AUTHORID</td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SOMEDATA</td>
		<td class='minwidth'>VARCHAR(30)</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>Z_FK_AUTHOR</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>AUTHORID (0..many)→ <a href='#authors_f521e766'>PUBLIC.BOOKS.AUTHORS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10118</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID (0..many)→ <a href='#books_f4a675c8'>PUBLIC.BOOKS.BOOKS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>Z_FK_AUTHOR</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>AUTHORID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10118</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>UIDX_BOOKAUTHORS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>AUTHORID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10116</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.BOOKAUTHORS.BOOKID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10117</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>AUTHORID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.BOOKAUTHORS.AUTHORID IS NOT NULL</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='books_f4a675c8' class='caption_name'>PUBLIC.BOOKS.BOOKS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td colspan='3' class='remarks'>Details for published books</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Unique (internal) id for book</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TITLE</td>
		<td class='minwidth'>VARCHAR(255) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Book title</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>DESCRIPTION</td>
		<td class='minwidth'>VARCHAR(255)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Book description
(Usually the blurb from the book jacket or promotional materials)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLISHERID</td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Foreign key to the book publisher</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONDATE</td>
		<td class='minwidth'>DATE</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Book publication date</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PRICE</td>
		<td class='minwidth'>DOUBLE(64, 0)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Current price for the book</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PREVIOUSEDITIONID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_BOOKS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_BOOK</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#sales_751e68cc'>PUBLIC."PUBLISHER SALES".SALES.BOOKID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10118</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#bookauthors_ead84c5d'>PUBLIC.BOOKS.BOOKAUTHORS.BOOKID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PREVIOUSEDITION</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..1) <a href='#books_f4a675c8'>PREVIOUSEDITIONID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_BOOKS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>U_PREVIOUSEDITION</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PREVIOUSEDITIONID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PREVIOUSEDITION</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PREVIOUSEDITIONID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>U_PREVIOUSEDITION</td>
		<td class='description right'>[unique constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PREVIOUSEDITIONID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10109</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.BOOKS.ID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10110</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TITLE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.BOOKS.TITLE IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10111</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLISHERID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.BOOKS.PUBLISHERID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Used By Objects</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS.BOOKAUTHORS</td>
		<td class='description right'>[table]</td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS.BOOKS</td>
		<td class='description right'>[table]</td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC."PUBLISHER SALES".SALES</td>
		<td class='description right'>[table]</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='celebrities_db1258df' class='caption_name'>PUBLIC.BOOKS."Celebrities"</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>"Id"</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>NAME</td>
		<td class='minwidth'>VARCHAR(20)</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>"PK_Celebrities"</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Id"</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10128</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Id" ←(0..1) <a href='#celebrityupdates_f5088e8b'>PUBLIC.BOOKS."Celebrity Updates"."Celebrity Id"</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>"PK_Celebrities"</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Id"</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10125</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Id"</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS."Celebrities"."Id" IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Used By Objects</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS."Celebrity Updates"</td>
		<td class='description right'>[table]</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='celebrityupdates_f5088e8b' class='caption_name'>PUBLIC.BOOKS."Celebrity Updates"</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>"Celebrity Id"</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"UPDATE"</td>
		<td class='minwidth'>VARCHAR(20)</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>"PK Celebrity Updates"</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Celebrity Id"</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10128</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Celebrity Id" (0..1)→ <a href='#celebrities_db1258df'>PUBLIC.BOOKS."Celebrities"."Id"</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>"PK Celebrity Updates"</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Celebrity Id"</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10128</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Celebrity Id"</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10127</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Celebrity Id"</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS."Celebrity Updates"."Celebrity Id" IS NOT NULL</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='coupons_54c3042b' class='caption_name'>PUBLIC.BOOKS.COUPONS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>DATA</td>
		<td class='minwidth'>CLOB</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUPONS</td>
		<td class='minwidth'>INTEGER ARRAY</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth'>default ARRAY[]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKS</td>
		<td class='minwidth'>VARCHAR(20) ARRAY[10]</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_COUPONS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_COUPONS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10091</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.COUPONS.ID IS NOT NULL</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='customerdata_b0af83c6' class='caption_name'>PUBLIC.BOOKS.CUSTOMERDATA</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>DATA</td>
		<td class='minwidth'>VALID_STRING(20)</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_CUSTOMERDATA</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_CUSTOMERDATA</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10100</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.CUSTOMERDATA.ID IS NOT NULL</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='customers_f705d773' class='caption_name'>PUBLIC.BOOKS.CUSTOMERS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'>NAME_TYPE NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'>NAME_TYPE NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>AGE</td>
		<td class='minwidth'>AGE_TYPE</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_CUSTOMERS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_CUSTOMERS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10093</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.CUSTOMERS.ID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10094</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.CUSTOMERS.FIRSTNAME IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10095</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.CUSTOMERS.LASTNAME IS NOT NULL</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='publishers_8037d535' class='caption_name'>PUBLIC.BOOKS.PUBLISHERS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td colspan='3' class='remarks'>List of book publishers</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth'>auto-incremented</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Unique (internal) id for book publisher</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLISHER</td>
		<td class='minwidth'>VARCHAR(255)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Name of book publisher</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_PK_10124</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_ΒΙΒΛΊΑ_PUBLISHERS</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#βιβλία_3cecb755'>PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_PK_10124</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Used By Objects</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS.ΒΙΒΛΊΑ</td>
		<td class='description right'>[table]</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='βιβλία_3cecb755' class='caption_name'>PUBLIC.BOOKS.ΒΙΒΛΊΑ</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ΜΟΝΑΔΙΚΌΣ</i></b></td>
		<td class='minwidth'>SMALLINT NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΤΊΤΛΟΣ</td>
		<td class='minwidth'>VARCHAR(255) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΠΕΡΙΓΡΑΦΉ</td>
		<td class='minwidth'>VARCHAR(255)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΕΚΔΌΤΗΣ</td>
		<td class='minwidth'>SMALLINT NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_ΒΙΒΛΊΑ</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΜΟΝΑΔΙΚΌΣ</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_ΒΙΒΛΊΑ_PUBLISHERS</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΕΚΔΌΤΗΣ (0..many)→ <a href='#publishers_8037d535'>PUBLIC.BOOKS.PUBLISHERS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_ΒΙΒΛΊΑ_PUBLISHERS</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΕΚΔΌΤΗΣ</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_ΒΙΒΛΊΑ</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΜΟΝΑΔΙΚΌΣ</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10131</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΜΟΝΑΔΙΚΌΣ</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10132</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΤΊΤΛΟΣ</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.ΒΙΒΛΊΑ.ΤΊΤΛΟΣ IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10133</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΕΚΔΌΤΗΣ</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ IS NOT NULL</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #F2E7C2;'>
		<span id='extra_pk_6ff01a79' class='caption_name'>PUBLIC.FOR_LINT.EXTRA_PK</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td colspan='3' class='remarks'>Extra table with just a primary key</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID</td>
		<td class='minwidth'>BIGINT NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONID</td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_EXTRA_PK</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PUBLICATION_JOIN</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONID (0..many)→ <a href='#publications_6ef89996'>PUBLIC.FOR_LINT.PUBLICATIONS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_WRITER_JOIN</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID (0..many)→ <a href='#writers_3778840f'>PUBLIC.FOR_LINT.WRITERS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_WRITER_JOIN</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_EXTRA_PK</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PUBLICATION_JOIN</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10182</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.EXTRA_PK.WRITERID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10183</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.EXTRA_PK.PUBLICATIONID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10184</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.EXTRA_PK.ID IS NOT NULL</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #F2E7C2;'>
		<span id='globalcounts_3c0c9230' class='caption_name'>PUBLIC.FOR_LINT."Global Counts"</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Global Count"</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #F2E7C2;'>
		<span id='publications_6ef89996' class='caption_name'>PUBLIC.FOR_LINT.PUBLICATIONS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TITLE</td>
		<td class='minwidth'>VARCHAR(255) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Publication title</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>DESCRIPTION</td>
		<td class='minwidth'>VARCHAR(255)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID</td>
		<td class='minwidth'>BIGINT NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONDATE</td>
		<td class='minwidth'>DATE</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PRICE</td>
		<td class='minwidth'>DOUBLE(64, 0)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"UPDATE"</td>
		<td class='minwidth'>CLOB</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PRESS_RELEASE</td>
		<td class='minwidth'>CLOB</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_PUBLICATIONS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PUBLICATION_JOIN</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#extra_pk_6ff01a79'>PUBLIC.FOR_LINT.EXTRA_PK.PUBLICATIONID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PUBLICATIONS_WRITER</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID (0..many)→ <a href='#writers_3778840f'>PUBLIC.FOR_LINT.WRITERS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PUBLICATION</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#publicationwriters_f68ea883'>PUBLIC.FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_WRITERS_PUBLICATION</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#writers_3778840f'>PUBLIC.FOR_LINT.WRITERS.PUBLICATION_ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PUBLICATIONS_WRITER</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_PUBLICATIONS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10167</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.PUBLICATIONS.ID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10168</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TITLE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.PUBLICATIONS.TITLE IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10169</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.PUBLICATIONS.WRITERID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Used By Objects</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.FOR_LINT.WRITERS</td>
		<td class='description right'>[table]</td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.FOR_LINT.EXTRA_PK</td>
		<td class='description right'>[table]</td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.FOR_LINT.PUBLICATIONWRITERS</td>
		<td class='description right'>[table]</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #F2E7C2;'>
		<span id='publicationwriters_f68ea883' class='caption_name'>PUBLIC.FOR_LINT.PUBLICATIONWRITERS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONID</td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID</td>
		<td class='minwidth'>BIGINT NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PUBLICATION</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONID (0..many)→ <a href='#publications_6ef89996'>PUBLIC.FOR_LINT.PUBLICATIONS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_WRITER</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID (0..many)→ <a href='#writers_3778840f'>PUBLIC.FOR_LINT.WRITERS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_WRITER</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PUBLICATION</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10174</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATIONID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10175</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>WRITERID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.PUBLICATIONWRITERS.WRITERID IS NOT NULL</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #F2E7C2;'>
		<span id='selfreference_836b0b2e' class='caption_name'>PUBLIC.FOR_LINT.SELFREFERENCE</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TITLE</td>
		<td class='minwidth'>VARCHAR(255) NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_SELFREFERENCE</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SELFREFERENCE</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..1) <a href='#selfreference_836b0b2e'>ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_SELFREFERENCE</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SELFREFERENCE</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10190</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.SELFREFERENCE.ID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10191</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TITLE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.SELFREFERENCE.TITLE IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Used By Objects</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.FOR_LINT.SELFREFERENCE</td>
		<td class='description right'>[table]</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #F2E7C2;'>
		<span id='writers_3778840f' class='caption_name'>PUBLIC.FOR_LINT.WRITERS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>BIGINT NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'>VARCHAR(20) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'>VARCHAR(20) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ADDRESS1</td>
		<td class='minwidth'>VARCHAR(255)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ADDRESS2</td>
		<td class='minwidth'>VARCHAR(255) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>CITY</td>
		<td class='minwidth'>VARCHAR(50)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'>VARCHAR(2)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'>VARCHAR(10)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>VARCHAR(50)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PHONE1</td>
		<td class='minwidth'>VARCHAR(10)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PHONE2</td>
		<td class='minwidth'>VARCHAR(15)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>EMAIL1</td>
		<td class='minwidth'>VARCHAR(10)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>EMAIL2</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FAX</td>
		<td class='minwidth'>VARCHAR(10)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FAX3</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>HOMEEMAIL11</td>
		<td class='minwidth'>VARCHAR(10)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>HOMEEMAIL12</td>
		<td class='minwidth'>VARCHAR(10)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATION_ID</td>
		<td class='minwidth'>BIGINT NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_WRITERS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_WRITER_JOIN</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#extra_pk_6ff01a79'>PUBLIC.FOR_LINT.EXTRA_PK.WRITERID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PUBLICATIONS_WRITER</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#publications_6ef89996'>PUBLIC.FOR_LINT.PUBLICATIONS.WRITERID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_WRITER</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#publicationwriters_f68ea883'>PUBLIC.FOR_LINT.PUBLICATIONWRITERS.WRITERID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_WRITERS_PUBLICATION</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATION_ID (0..many)→ <a href='#publications_6ef89996'>PUBLIC.FOR_LINT.PUBLICATIONS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_WRITERS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_WRITERS_PUBLICATION</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATION_ID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>IDX_A1_WRITERS</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>CITY</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>IDX_U_WRITERS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>EMAIL1</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>IDX_B_WRITERS</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>IDX_A_WRITERS</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>CITY</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>CHECK_UPPERCASE_STATE</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.WRITERS.STATE=UPPER(FOR_LINT.WRITERS.STATE)</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10156</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.WRITERS.ID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10157</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.WRITERS.FIRSTNAME IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10158</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.WRITERS.LASTNAME IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10159</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ADDRESS2</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.WRITERS.ADDRESS2 IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10160</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLICATION_ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>FOR_LINT.WRITERS.PUBLICATION_ID IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Used By Objects</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.FOR_LINT.PUBLICATIONS</td>
		<td class='description right'>[table]</td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.FOR_LINT.EXTRA_PK</td>
		<td class='description right'>[table]</td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC.FOR_LINT.PUBLICATIONWRITERS</td>
		<td class='description right'>[table]</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #F2D6C2;'>
		<span id='regions_dbf65bbf' class='caption_name'>PUBLIC."PUBLISHER SALES".REGIONS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>CITY</td>
		<td class='minwidth'>VARCHAR(50) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'>VARCHAR(2) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>POSTALCODE</i></b></td>
		<td class='minwidth'>VARCHAR(10) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>COUNTRY</i></b></td>
		<td class='minwidth'>VARCHAR(50) NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_CUSTOMERS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_REGIONS</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE ←(0..many) <a href='#sales_751e68cc'>PUBLIC."PUBLISHER SALES".SALES.POSTALCODE</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY ←(0..many) <a href='#sales_751e68cc'>PUBLIC."PUBLISHER SALES".SALES.COUNTRY</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_CUSTOMERS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10204</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>CITY</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>"PUBLISHER SALES".REGIONS.CITY IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10205</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>"PUBLISHER SALES".REGIONS.STATE IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10206</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>"PUBLISHER SALES".REGIONS.POSTALCODE IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10207</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>"PUBLISHER SALES".REGIONS.COUNTRY IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Used By Objects</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC."PUBLISHER SALES".SALES</td>
		<td class='description right'>[table]</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #F2D6C2;'>
		<span id='sales_751e68cc' class='caption_name'>PUBLIC."PUBLISHER SALES".SALES</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'>VARCHAR(10) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>VARCHAR(50) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUPON_ID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PERIODENDDATE</td>
		<td class='minwidth'>DATE</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TOTALAMOUNT</td>
		<td class='minwidth'>DOUBLE(64, 0)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_BOOK</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID (0..many)→ <a href='#books_f4a675c8'>PUBLIC.BOOKS.BOOKS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_SALESDATA</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID (0..many)→ <a href='#salesdata_1193fa76'>PUBLIC."PUBLISHER SALES".SALESDATA.SALESDATAID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_REGIONS</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE (0..many)→ <a href='#regions_dbf65bbf'>PUBLIC."PUBLISHER SALES".REGIONS.POSTALCODE</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY (0..many)→ <a href='#regions_dbf65bbf'>PUBLIC."PUBLISHER SALES".REGIONS.COUNTRY</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_BOOK</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_SALESDATA</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_REGIONS</td>
		<td class='description right'>[non-unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10213</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>"PUBLISHER SALES".SALES.POSTALCODE IS NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_CT_10214</td>
		<td class='description right'>[check constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>"PUBLISHER SALES".SALES.COUNTRY IS NOT NULL</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #F2D6C2;'>
		<span id='salesdata_1193fa76' class='caption_name'>PUBLIC."PUBLISHER SALES".SALESDATA</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>YEARLYAMOUNT</td>
		<td class='minwidth'>DOUBLE(64, 0)</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_SALESDATA</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID ←(0..many) <a href='#sales_751e68cc'>PUBLIC."PUBLISHER SALES".SALES.SALESDATAID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Indexes</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>UQ_CUSTOMERS</td>
		<td class='description right'>[unique index]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID</td>
		<td class='minwidth'>ascending</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Table Constraints</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>UQ_CUSTOMERS</td>
		<td class='description right'>[unique constraint]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Used By Objects</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PUBLIC."PUBLISHER SALES".SALES</td>
		<td class='description right'>[table]</td>
	</tr>
</table>
<p>&#160;</p>

<p>&#160;</p>
<h2>Routines</h2>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='getbookscount_10155_e0b12ab5' class='caption_name'>PUBLIC.BOOKS.GETBOOKSCOUNT</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKSCOUNT</td>
		<td class='minwidth'>INTEGER, out</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>GETBOOKSCOUNT_10155</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE BOOKS.GETBOOKSCOUNT(OUT BOOKSCOUNT INTEGER) SPECIFIC GETBOOKSCOUNT_10155 LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC SELECT COUNT(*)INTO BOOKSCOUNT FROM BOOKS.BOOKS;END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='new_publisher_force_value_7d16ddc0' class='caption_name'>PUBLIC.BOOKS.NEW_PUBLISHER</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLISHER</td>
		<td class='minwidth'>CHARACTER VARYING, out</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>NEW_PUBLISHER_FORCE_VALUE</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE BOOKS.NEW_PUBLISHER(OUT PUBLISHER VARCHAR(50)) SPECIFIC NEW_PUBLISHER_FORCE_VALUE LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL NEW SAVEPOINT LEVEL SET PUBLISHER = 'New Publisher'</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='new_publisher_10151_43f13171' class='caption_name'>PUBLIC.BOOKS.NEW_PUBLISHER</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>NEWPUBLISHER</td>
		<td class='minwidth'>CHARACTER VARYING, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PUBLISHER</td>
		<td class='minwidth'>CHARACTER VARYING, out</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>NEW_PUBLISHER_10151</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE BOOKS.NEW_PUBLISHER(IN NEWPUBLISHER VARCHAR(50),OUT PUBLISHER VARCHAR(50)) SPECIFIC NEW_PUBLISHER_10151 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL NEW SAVEPOINT LEVEL SET PUBLISHER = NEWPUBLISHER</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='customadd_10153_a370a993' class='caption_name'>PUBLIC.BOOKS.CUSTOMADD</span>
		<span class='caption_description'>[function, does not return a table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ONE</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>CUSTOMADD_10153</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE FUNCTION BOOKS.CUSTOMADD(IN ONE INTEGER) RETURNS INTEGER SPECIFIC CUSTOMADD_10153 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL CALLED ON NULL INPUT RETURN BOOKS.CUSTOMADD(ONE,1)</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2DCF2;'>
		<span id='customadd_10152_a370a992' class='caption_name'>PUBLIC.BOOKS.CUSTOMADD</span>
		<span class='caption_description'>[function, does not return a table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ONE</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TWO</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>CUSTOMADD_10152</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE FUNCTION BOOKS.CUSTOMADD(IN ONE INTEGER,IN TWO INTEGER) RETURNS INTEGER SPECIFIC CUSTOMADD_10152 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL CALLED ON NULL INPUT RETURN ONE+TWO</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='alloc_blocks_10071_8321c228' class='caption_name'>PUBLIC.SYSTEM_LOBS.ALLOC_BLOCKS</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_COUNT</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_OFFSET</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>L_ID</td>
		<td class='minwidth'>BIGINT, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>ALLOC_BLOCKS_10071</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.ALLOC_BLOCKS(IN B_COUNT INTEGER,IN B_OFFSET INTEGER,IN L_ID BIGINT) SPECIFIC ALLOC_BLOCKS_10071 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC DECLARE LOB_ADDR INT DEFAULT NULL;DECLARE REMAINING_COUNT INT DEFAULT 0;DECLARE BL_ADDR INT DEFAULT NULL;DECLARE TEMP_COUNT INT DEFAULT 0;DECLARE BL_OFFSET INT DEFAULT 0;SET REMAINING_COUNT=B_COUNT;SET BL_OFFSET=B_OFFSET;MAIN_LOOP:LOOP SET BL_ADDR=(SELECT BLOCK_ADDR FROM SYSTEM_LOBS.BLOCKS WHERE BLOCK_COUNT=REMAINING_COUNT AND TX_ID=0 FETCH 1 ROW ONLY);IF BL_ADDR IS NOT NULL THEN CALL CONVERT_BLOCK(BL_ADDR,REMAINING_COUNT,BL_OFFSET,L_ID);IF LOB_ADDR IS NULL THEN SET LOB_ADDR=BL_ADDR;END IF;LEAVE MAIN_LOOP;END IF;SET(BL_ADDR,TEMP_COUNT)=(SELECT BLOCK_ADDR,BLOCK_COUNT FROM SYSTEM_LOBS.BLOCKS WHERE BLOCK_COUNT&lt;REMAINING_COUNT AND TX_ID=0 FETCH 1 ROW ONLY);IF BL_ADDR IS NOT NULL THEN CALL CONVERT_BLOCK(BL_ADDR,TEMP_COUNT,BL_OFFSET,L_ID);IF LOB_ADDR IS NULL THEN SET LOB_ADDR=BL_ADDR;END IF;SET REMAINING_COUNT=REMAINING_COUNT-TEMP_COUNT;SET BL_OFFSET=BL_OFFSET+TEMP_COUNT;SET BL_ADDR=NULL;SET TEMP_COUNT=0;ELSE CALL CREATE_EMPTY_BLOCK(BL_ADDR,REMAINING_COUNT);CALL CONVERT_BLOCK(BL_ADDR,REMAINING_COUNT,BL_OFFSET,L_ID);IF LOB_ADDR IS NULL THEN SET LOB_ADDR=BL_ADDR;END IF;LEAVE MAIN_LOOP;END IF;END LOOP MAIN_LOOP;END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='alloc_single_block_10074_58db942b' class='caption_name'>PUBLIC.SYSTEM_LOBS.ALLOC_SINGLE_BLOCK</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_COUNT</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_OFFSET</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>L_ID</td>
		<td class='minwidth'>BIGINT, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>ALLOC_SINGLE_BLOCK_10074</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.ALLOC_SINGLE_BLOCK(IN B_COUNT INTEGER,IN B_OFFSET INTEGER,IN L_ID BIGINT) SPECIFIC ALLOC_SINGLE_BLOCK_10074 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC DECLARE BL_ADDR INT DEFAULT NULL;SET BL_ADDR=(SELECT BLOCK_ADDR FROM SYSTEM_LOBS.BLOCKS WHERE BLOCK_COUNT=B_COUNT AND TX_ID=0 FETCH 1 ROW ONLY);IF BL_ADDR IS NULL THEN CALL CREATE_EMPTY_BLOCK(BL_ADDR,B_COUNT);END IF;CALL CONVERT_BLOCK(BL_ADDR,B_COUNT,B_OFFSET,L_ID);END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='convert_block_10029_e3b2baf5' class='caption_name'>PUBLIC.SYSTEM_LOBS.CONVERT_BLOCK</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_ADDR</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_COUNT</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_OFFSET</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>L_ID</td>
		<td class='minwidth'>BIGINT, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>CONVERT_BLOCK_10029</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.CONVERT_BLOCK(IN B_ADDR INTEGER,IN B_COUNT INTEGER,IN B_OFFSET INTEGER,IN L_ID BIGINT) SPECIFIC CONVERT_BLOCK_10029 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC DELETE FROM SYSTEM_LOBS.BLOCKS WHERE BLOCK_ADDR=B_ADDR;INSERT INTO SYSTEM_LOBS.LOBS(BLOCK_ADDR,BLOCK_COUNT,BLOCK_OFFSET,LOB_ID) VALUES(B_ADDR,B_COUNT,B_OFFSET,L_ID);END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='create_empty_block_10063_9ee8490b' class='caption_name'>PUBLIC.SYSTEM_LOBS.CREATE_EMPTY_BLOCK</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_ADDR</td>
		<td class='minwidth'>INTEGER, in/ out</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_COUNT</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>CREATE_EMPTY_BLOCK_10063</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.CREATE_EMPTY_BLOCK(INOUT B_ADDR INTEGER,IN B_COUNT INTEGER) SPECIFIC CREATE_EMPTY_BLOCK_10063 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC DECLARE TEMP_COUNT INT DEFAULT NULL;DECLARE TEMP_ADDR INT DEFAULT NULL;SET(TEMP_ADDR,TEMP_COUNT)=(SELECT BLOCK_ADDR,BLOCK_COUNT FROM SYSTEM_LOBS.BLOCKS WHERE BLOCK_COUNT&gt;B_COUNT AND TX_ID=0 FETCH 1 ROW ONLY);IF TEMP_ADDR IS NULL THEN SIGNAL SQLSTATE'45000';END IF;UPDATE SYSTEM_LOBS.BLOCKS SET BLOCK_COUNT=B_COUNT WHERE BLOCK_ADDR=TEMP_ADDR;INSERT INTO SYSTEM_LOBS.BLOCKS(BLOCK_ADDR,BLOCK_COUNT,TX_ID) VALUES(TEMP_ADDR+B_COUNT,TEMP_COUNT-B_COUNT,0);SET B_ADDR=TEMP_ADDR;END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='delete_blocks_10060_255fafc8' class='caption_name'>PUBLIC.SYSTEM_LOBS.DELETE_BLOCKS</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>L_ID</td>
		<td class='minwidth'>BIGINT, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_OFFSET</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_LIMIT</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TX_ID</td>
		<td class='minwidth'>BIGINT, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>DELETE_BLOCKS_10060</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.DELETE_BLOCKS(IN L_ID BIGINT,IN B_OFFSET INTEGER,IN B_LIMIT INTEGER,IN TX_ID BIGINT) SPECIFIC DELETE_BLOCKS_10060 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC INSERT INTO SYSTEM_LOBS.BLOCKS(BLOCK_ADDR,BLOCK_COUNT,TX_ID)(SELECT BLOCK_ADDR,BLOCK_COUNT,TX_ID FROM SYSTEM_LOBS.LOBS WHERE LOBS.LOB_ID=L_ID AND BLOCK_OFFSET&gt;=B_OFFSET AND BLOCK_OFFSET&lt;B_LIMIT);DELETE FROM SYSTEM_LOBS.LOBS WHERE LOBS.LOB_ID=L_ID AND BLOCK_OFFSET&gt;=B_OFFSET AND BLOCK_OFFSET&lt;B_LIMIT;END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='delete_lob_10031_2c23b4cc' class='caption_name'>PUBLIC.SYSTEM_LOBS.DELETE_LOB</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>L_ID</td>
		<td class='minwidth'>BIGINT, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TX_ID</td>
		<td class='minwidth'>BIGINT, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>DELETE_LOB_10031</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.DELETE_LOB(IN L_ID BIGINT,IN TX_ID BIGINT) SPECIFIC DELETE_LOB_10031 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC INSERT INTO SYSTEM_LOBS.BLOCKS(BLOCK_ADDR,BLOCK_COUNT,TX_ID)(SELECT BLOCK_ADDR,BLOCK_COUNT,TX_ID FROM SYSTEM_LOBS.LOBS WHERE LOBS.LOB_ID=L_ID);DELETE FROM SYSTEM_LOBS.LOBS WHERE LOBS.LOB_ID=L_ID;DELETE FROM SYSTEM_LOBS.PARTS WHERE LOB_ID=L_ID;DELETE FROM SYSTEM_LOBS.LOB_IDS WHERE LOB_IDS.LOB_ID=L_ID;END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='delete_unused_10046_476f3d90' class='caption_name'>PUBLIC.SYSTEM_LOBS.DELETE_UNUSED</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>L_IDS</td>
		<td class='minwidth'>BIGINT ARRAY, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>DELETE_UNUSED_10046</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.DELETE_UNUSED(IN L_IDS BIGINT ARRAY) SPECIFIC DELETE_UNUSED_10046 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC DECLARE TABLE LIVE_IDS(LIVE_ID INT);DECLARE TABLE TEMP_IDS(TEMP_ID INT);DECLARE TEMP_COUNT INT DEFAULT 1;WHILE TEMP_COUNT&lt;=CARDINALITY(L_IDS)DO INSERT INTO LIVE_IDS(LIVE_ID) VALUES L_IDS[TEMP_COUNT];SET TEMP_COUNT=TEMP_COUNT+1;END WHILE;SET TEMP_COUNT=0;REPEAT INSERT INTO TEMP_IDS(TEMP_ID) SELECT LOB_IDS.LOB_ID FROM SYSTEM_LOBS.LOB_IDS WHERE LOB_USAGE_COUNT&lt;1 AND LOB_IDS.LOB_ID NOT IN(SELECT LIVE_ID FROM LIVE_IDS)LIMIT 1000;INSERT INTO SYSTEM_LOBS.BLOCKS(BLOCK_ADDR,BLOCK_COUNT,TX_ID)(SELECT BLOCK_ADDR,BLOCK_COUNT,0 FROM SYSTEM_LOBS.LOBS WHERE LOBS.LOB_ID IN(SELECT TEMP_ID FROM TEMP_IDS));DELETE FROM SYSTEM_LOBS.LOBS WHERE LOBS.LOB_ID IN(SELECT TEMP_ID FROM TEMP_IDS);DELETE FROM SYSTEM_LOBS.PARTS WHERE LOB_ID IN(SELECT TEMP_ID FROM TEMP_IDS);DELETE FROM SYSTEM_LOBS.LOB_IDS WHERE LOB_IDS.LOB_ID IN(SELECT TEMP_ID FROM TEMP_IDS);GET DIAGNOSTICS TEMP_COUNT=ROW_COUNT;DELETE FROM TEMP_IDS;UNTIL TEMP_COUNT&lt;1000 END REPEAT;END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='delete_unused_lobs_10058_7b410651' class='caption_name'>PUBLIC.SYSTEM_LOBS.DELETE_UNUSED_LOBS</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LIMIT_ID</td>
		<td class='minwidth'>BIGINT, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>TOTAL_COUNT</td>
		<td class='minwidth'>INTEGER, out</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>DELETE_UNUSED_LOBS_10058</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.DELETE_UNUSED_LOBS(IN LIMIT_ID BIGINT,OUT TOTAL_COUNT INTEGER) SPECIFIC DELETE_UNUSED_LOBS_10058 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC DECLARE TABLE TEMP_IDS(TEMP_ID INT);DECLARE TEMP_COUNT INT DEFAULT 0;DECLARE TOTAL INT DEFAULT 0;REPEAT INSERT INTO TEMP_IDS(TEMP_ID) SELECT LOB_IDS.LOB_ID FROM SYSTEM_LOBS.LOB_IDS WHERE LOB_USAGE_COUNT=0 AND LOB_IDS.LOB_ID&lt;LIMIT_ID LIMIT 1000;INSERT INTO SYSTEM_LOBS.BLOCKS(BLOCK_ADDR,BLOCK_COUNT,TX_ID)(SELECT BLOCK_ADDR,BLOCK_COUNT,0 FROM SYSTEM_LOBS.LOBS WHERE LOBS.LOB_ID IN(SELECT TEMP_ID FROM TEMP_IDS));DELETE FROM SYSTEM_LOBS.LOBS WHERE LOBS.LOB_ID IN(SELECT TEMP_ID FROM TEMP_IDS);DELETE FROM SYSTEM_LOBS.PARTS WHERE LOB_ID IN(SELECT TEMP_ID FROM TEMP_IDS);DELETE FROM SYSTEM_LOBS.LOB_IDS WHERE LOB_IDS.LOB_ID IN(SELECT TEMP_ID FROM TEMP_IDS);GET DIAGNOSTICS TEMP_COUNT=ROW_COUNT;SET TOTAL=TOTAL+TEMP_COUNT;DELETE FROM TEMP_IDS;UNTIL TEMP_COUNT&lt;1000 END REPEAT;SET TOTAL_COUNT=TOTAL;END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='divide_block_10066_3a3523ae' class='caption_name'>PUBLIC.SYSTEM_LOBS.DIVIDE_BLOCK</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>B_OFFSET</td>
		<td class='minwidth'>INTEGER, in</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>L_ID</td>
		<td class='minwidth'>BIGINT, in</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>DIVIDE_BLOCK_10066</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.DIVIDE_BLOCK(IN B_OFFSET INTEGER,IN L_ID BIGINT) SPECIFIC DIVIDE_BLOCK_10066 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC DECLARE BL_ADDR INT DEFAULT NULL;DECLARE BL_COUNT INT DEFAULT NULL;DECLARE BL_OFFSET INT DEFAULT NULL;SET(BL_ADDR,BL_COUNT,BL_OFFSET)=(SELECT BLOCK_ADDR,BLOCK_COUNT,BLOCK_OFFSET FROM SYSTEM_LOBS.LOBS WHERE LOBS.LOB_ID=L_ID AND B_OFFSET&gt;BLOCK_OFFSET AND B_OFFSET&lt;BLOCK_OFFSET+BLOCK_COUNT);IF BL_ADDR IS NULL THEN SIGNAL SQLSTATE'45000';END IF;DELETE FROM SYSTEM_LOBS.LOBS WHERE BLOCK_ADDR=BL_ADDR;INSERT INTO SYSTEM_LOBS.LOBS(BLOCK_ADDR,BLOCK_COUNT,BLOCK_OFFSET,LOB_ID) VALUES(BL_ADDR,B_OFFSET-BL_OFFSET,BL_OFFSET,L_ID);INSERT INTO SYSTEM_LOBS.LOBS(BLOCK_ADDR,BLOCK_COUNT,BLOCK_OFFSET,LOB_ID) VALUES(BL_ADDR+B_OFFSET-BL_OFFSET,BL_OFFSET+BL_COUNT-B_OFFSET,B_OFFSET,L_ID);END</td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #C2D6F2;'>
		<span id='merge_empty_blocks_10079_9825f8d0' class='caption_name'>PUBLIC.SYSTEM_LOBS.MERGE_EMPTY_BLOCKS</span>
		<span class='caption_description'>[procedure, no result]</span>
	</caption>

	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[specific name]</td>
	</tr>
	<tr>
		<td colspan='3'>MERGE_EMPTY_BLOCKS_10079</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Definition</td>
	</tr>
	<tr>
		<td colspan='2' class='name'></td>
		<td class='description right'>[definition]</td>
	</tr>
	<tr>
		<td colspan='3' class='definition'>CREATE PROCEDURE SYSTEM_LOBS.MERGE_EMPTY_BLOCKS() SPECIFIC MERGE_EMPTY_BLOCKS_10079 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC DECLARE BL_BASE_ADDR INT DEFAULT-1;DECLARE BL_BASE_COUNT INT;DECLARE BL_ADDR INT;DECLARE BL_COUNT INT;DECLARE BL_MERGE BOOLEAN;REPEAT SET BL_BASE_COUNT=NULL;SET(BL_BASE_ADDR,BL_BASE_COUNT)=(SELECT BLOCK_ADDR,BLOCK_COUNT FROM SYSTEM_LOBS.BLOCKS WHERE BLOCK_ADDR&gt;BL_BASE_ADDR ORDER BY BLOCK_ADDR FETCH 1 ROW ONLY);IF BL_BASE_COUNT IS NOT NULL THEN SET BL_MERGE=FALSE;REPEAT SET BL_ADDR=NULL;SET(BL_ADDR,BL_COUNT)=(SELECT BLOCK_ADDR,BLOCK_COUNT FROM SYSTEM_LOBS.BLOCKS WHERE BLOCK_ADDR=BL_BASE_ADDR+BL_BASE_COUNT);IF BL_ADDR IS NOT NULL THEN SET BL_BASE_COUNT=BL_BASE_COUNT+BL_COUNT;SET BL_MERGE=TRUE;END IF;UNTIL BL_ADDR IS NULL END REPEAT;IF BL_MERGE THEN DELETE FROM SYSTEM_LOBS.BLOCKS WHERE BLOCK_ADDR&gt;=BL_BASE_ADDR AND BLOCK_ADDR&lt;BL_BASE_ADDR+BL_BASE_COUNT;INSERT INTO SYSTEM_LOBS.BLOCKS(BLOCK_ADDR,BLOCK_COUNT,TX_ID) VALUES BL_BASE_ADDR,BL_BASE_COUNT,0;END IF;END IF;UNTIL BL_BASE_COUNT IS NULL END REPEAT;END</td>
	</tr>
</table>
<p>&#160;</p>

<p>&#160;</p>
<h2>Data Types</h2>

<table>
	<tr>
		<td colspan='2' class='name'>BIGINT</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>BINARY</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with LENGTH</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>BIT</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with LENGTH</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>BLOB</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with LENGTH</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not searchable</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>BOOLEAN</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>CHARACTER</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with LENGTH</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>CLOB</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with LENGTH</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not searchable</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>DATE</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>DECIMAL</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with PRECISION,SCALE</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>DOUBLE</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>FLOAT</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>INTEGER</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>NUMERIC</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with PRECISION,SCALE</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>NVARCHAR</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with LENGTH</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>OTHER</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>REAL</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>SMALLINT</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>TIME</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>TIMESTAMP</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>TIMESTAMP WITH TIME ZONE</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>TIME WITH TIME ZONE</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>TINYINT</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable except with where .. like</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>UUID</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>VARBINARY</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with LENGTH</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>VARCHAR</td>
		<td class='description right'>[data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with LENGTH</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>searchable</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS.AGE_TYPE</td>
		<td class='description right'>[user defined data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not searchable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>based on</td>
		<td class='minwidth'>SMALLINT</td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS."CHARACTER VARYING"</td>
		<td class='description right'>[user defined data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not searchable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>based on</td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS."INTEGER ARRAY"</td>
		<td class='description right'>[user defined data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not searchable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>based on</td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS.NAME_TYPE</td>
		<td class='description right'>[user defined data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not searchable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>based on</td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS.VALID_STRING</td>
		<td class='description right'>[user defined data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not searchable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>based on</td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>PUBLIC.BOOKS."VARCHAR(20) ARRAY[10]"</td>
		<td class='description right'>[user defined data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not searchable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>based on</td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>

<table>
	<tr>
		<td colspan='2' class='name'>PUBLIC.SYSTEM_LOBS."BIGINT ARRAY"</td>
		<td class='description right'>[user defined data type]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>defined with no parameters</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not nullable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not auto-incrementable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td colspan='2'>not searchable</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>based on</td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>

<p>&#160;</p>
<h2>System Information</h2>


<h3>Database Information</h3>

<table>
	<tr>
		<td class='property_name'>database product name</td>
		<td class='property_value'>HSQL Database Engine</td>
	</tr>
	<tr>
		<td class='property_name'>database product version</td>
		<td class='property_value'>2.7.4</td>
	</tr>
	<tr>
		<td class='property_name'>database user name</td>
		<td class='property_value'>SA</td>
	</tr>
</table>
<p>&#160;</p>


<h3>JDBC Driver Information</h3>

<table>
	<tr>
		<td class='property_name'>connection url</td>
		<td class='property_value'>jdbc:hsqldb:hsql://0.0.0.0:57354/schemacrawler57354</td>
	</tr>
	<tr>
		<td class='property_name'>driver name</td>
		<td class='property_value'>HSQL Database Engine Driver</td>
	</tr>
	<tr>
		<td class='property_name'>driver version</td>
		<td class='property_value'>2.7.4</td>
	</tr>
	<tr>
		<td class='property_name'>driver class name</td>
		<td class='property_value'>org.hsqldb.jdbc.JDBCDriver</td>
	</tr>
	<tr>
		<td class='property_name'>is JDBC compliant</td>
		<td class='property_value'>true</td>
	</tr>
	<tr>
		<td class='property_name'>supported JDBC version</td>
		<td class='property_value'>4.2</td>
	</tr>
</table>
<p>&#160;</p>

</body>
</html>
